package com.ai.bitcoin.jpa.dao;

import com.ai.bitcoin.jpa.entity.BccSubCoinAction;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface BccSubCoinActionDao extends JpaRepository<BccSubCoinAction, String> {

    @Query(value = "select * from bcc_sub_coin_action where user_symbol = ?1  order by create_time desc", nativeQuery = true)
    List<BccSubCoinAction> queryByUserSymbol(String openId);

}
